

--------------------------------------------------------------------
--Nombre: SP_ListarMaterial
--Objetivo: Listar los registros de la tabla Material
--Creacion    : TISI(GOS) 20130226
--------------------------------------------------------------------

CREATE PROCEDURE SP_ListarMaterial
AS
BEGIN
  SELECT
  IDMaterial,
    CodMate,
    TipoMate,
    FamiMate,
    SubFamiMate,
    CatMate,
    SubCatMate,
    DescMate,
    UniMedMate,
    CostoPromMate,
    PrecPromMate,
    SaldActMate,
    StckMinMate,
    StckRepoMate,
    EstadoMate,
    UsuReg,
    FecReg,
    TermCnxReg,
    UsuMod,
    FecMod,
    TermCnxMod,
    IDEmp
  FROM
  Material
END
GO
  